Quiz!

Quiz on functional dependencies.

Which axiom states that every non-key attribute must be fully dependent on the whole composite primary key?

A)

Axiom of Reflexivity

B)

Axiom of Augmentation (partial dependency)

C)

Axiom of Transitivity (transitive dependnecy)

D)

None of the above

Question 1 of 40 attempted

This brings us to the end of this chapter. By now you should be familiar with the rules and types of dependencies, as well as the representation of dependencies in our database schemas.

In the next chapter, we will see how functional dependencies are removed through normalization.

Dependency Diagrams

What Is Normalization?

Mark as Completed

Report an Issue

Introduction

Fundamental Concepts

Data Modeling

Entity-Relationship Data Model

The Relational Data Model

Functional Dependencies

Normalization

Structured Query Language

Conclusion

Quiz!

A)

B)

C)

D)